MyOffice Spreadsheet

Delete columns or rows

To delete one or multiple rows or columns, select these rows or columns or cells in these rows or columns and do one of the following:

•In the Table menu, select Delete Column or Delete Row.

•On the Toolbar, select the Cells section and click Delete Column or Delete Row.

•Right-click any place of the selected range and select Delete Column or Delete Row from the context menu.

•Select these columns or rows entirely and press Ctrl+—.

If there are filtered data or manually hidden columns or rows, only the visible columns or rows will be deleted with the following exceptions:

•If you delete a column in its entirety, the cells in the hidden rows will be deleted along with it.

•If you delete a row in its entirety, cells from hidden columns will be deleted along with it.